Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 577262 |
| Missing cells | 2779102 |
| Missing cells (%) | 15.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 136.5 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Text | 6 |
CANCELLED is highly imbalanced (85.2%) | Imbalance |
DIVERTED is highly imbalanced (96.3%) | Imbalance |
DEP_TIME has 11603 (2.0%) missing values | Missing |
DEP_DELAY has 11607 (2.0%) missing values | Missing |
TAXI_OUT has 12137 (2.1%) missing values | Missing |
TAXI_IN has 12413 (2.2%) missing values | Missing |
ARR_TIME has 12413 (2.2%) missing values | Missing |
ARR_DELAY has 14458 (2.5%) missing values | Missing |
CANCELLATION_CODE has 565043 (97.9%) missing values | Missing |
AIR_TIME has 14458 (2.5%) missing values | Missing |
CARRIER_DELAY has 424994 (73.6%) missing values | Missing |
WEATHER_DELAY has 424994 (73.6%) missing values | Missing |
NAS_DELAY has 424994 (73.6%) missing values | Missing |
SECURITY_DELAY has 424994 (73.6%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 424994 (73.6%) missing values | Missing |
SECURITY_DELAY is highly skewed (γ1 = 40.74569553) | Skewed |
DEP_DELAY has 26175 (4.5%) zeros | Zeros |
ARR_DELAY has 10607 (1.8%) zeros | Zeros |
CARRIER_DELAY has 64488 (11.2%) zeros | Zeros |
WEATHER_DELAY has 141926 (24.6%) zeros | Zeros |
NAS_DELAY has 79641 (13.8%) zeros | Zeros |
SECURITY_DELAY has 151369 (26.2%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 68409 (11.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 06:08:01.581862 |
|---|---|
| Analysis finished | 2024-03-30 06:10:58.286115 |
| Duration | 2 minutes and 56.7 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.010432 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9376956 |
|---|---|
| Coefficient of variation (CV) | 0.4831638 |
| Kurtosis | -1.1307111 |
| Mean | 4.010432 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.036328573 |
| Sum | 2315070 |
| Variance | 3.7546641 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 5 | 99853 | |
| 4 | 99601 | |
| 1 | 79769 | |
| 7 | 77241 | |
| 3 | 76217 | |
| 2 | 74798 | |
| 6 | 69783 |
| Value | Count | Frequency (%) |
| 1 | 79769 | |
| 2 | 74798 | |
| 3 | 76217 | |
| 4 | 99601 | |
| 5 | 99853 | |
| 6 | 69783 | |
| 7 | 77241 |
| Value | Count | Frequency (%) |
| 7 | 77241 | |
| 6 | 69783 | |
| 5 | 99853 | |
| 4 | 99601 | |
| 3 | 76217 | |
| 2 | 74798 | |
| 1 | 79769 |
FL_DATE
Date
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| Minimum | 2023-06-01 00:00:00 |
|---|---|
| Maximum | 2023-06-30 00:00:00 |
Histogram with fixed size bins (bins=30)
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1154524 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 119251 | |
| DL | 85929 | |
| AA | 80416 | |
| UA | 62395 | |
| OO | 56372 | |
| YX | 23752 | 4.1% |
| B6 | 22795 | 3.9% |
| AS | 21337 | 3.7% |
| NK | 21155 | 3.7% |
| 9E | 17307 | 3.0% |
| Other values (5) | 66553 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 119251 | |
| dl | 85929 | |
| aa | 80416 | |
| ua | 62395 | |
| oo | 56372 | |
| yx | 23752 | 4.1% |
| b6 | 22795 | 3.9% |
| as | 21337 | 3.7% |
| nk | 21155 | 3.7% |
| 9e | 17307 | 3.0% |
| Other values (5) | 66553 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 251396 | |
| N | 140406 | |
| O | 129869 | |
| W | 119251 | |
| D | 85929 | 7.4% |
| L | 85929 | 7.4% |
| U | 62395 | 5.4% |
| 9 | 31244 | 2.7% |
| H | 23957 | 2.1% |
| Y | 23752 | 2.1% |
| Other values (11) | 200396 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1154524 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 251396 | |
| N | 140406 | |
| O | 129869 | |
| W | 119251 | |
| D | 85929 | 7.4% |
| L | 85929 | 7.4% |
| U | 62395 | 5.4% |
| 9 | 31244 | 2.7% |
| H | 23957 | 2.1% |
| Y | 23752 | 2.1% |
| Other values (11) | 200396 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1154524 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 251396 | |
| N | 140406 | |
| O | 129869 | |
| W | 119251 | |
| D | 85929 | 7.4% |
| L | 85929 | 7.4% |
| U | 62395 | 5.4% |
| 9 | 31244 | 2.7% |
| H | 23957 | 2.1% |
| Y | 23752 | 2.1% |
| Other values (11) | 200396 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1154524 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 251396 | |
| N | 140406 | |
| O | 129869 | |
| W | 119251 | |
| D | 85929 | 7.4% |
| L | 85929 | 7.4% |
| U | 62395 | 5.4% |
| 9 | 31244 | 2.7% |
| H | 23957 | 2.1% |
| Y | 23752 | 2.1% |
| Other values (11) | 200396 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5936 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2324.8165 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 279 |
| Q1 | 1044 |
| median | 2082 |
| Q3 | 3361 |
| 95-th percentile | 5394 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2317 |
Descriptive statistics
| Standard deviation | 1580.8162 |
|---|---|
| Coefficient of variation (CV) | 0.67997464 |
| Kurtosis | -0.62942795 |
| Mean | 2324.8165 |
| Median Absolute Deviation (MAD) | 1117 |
| Skewness | 0.58704669 |
| Sum | 1.3420282 × 109 |
| Variance | 2498979.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2385 | 341 | 0.1% |
| 352 | 310 | 0.1% |
| 1008 | 307 | 0.1% |
| 1267 | 298 | 0.1% |
| 2607 | 296 | 0.1% |
| 555 | 292 | 0.1% |
| 470 | 289 | 0.1% |
| 777 | 289 | 0.1% |
| 323 | 286 | < 0.1% |
| 1191 | 283 | < 0.1% |
| Other values (5926) | 574271 |
| Value | Count | Frequency (%) |
| 1 | 182 | |
| 2 | 176 | |
| 3 | 177 | |
| 4 | 187 | |
| 5 | 106 | |
| 6 | 88 | |
| 7 | 130 | |
| 8 | 125 | |
| 9 | 206 | |
| 10 | 185 |
| Value | Count | Frequency (%) |
| 8819 | 2 | |
| 8818 | 1 | < 0.1% |
| 8810 | 1 | < 0.1% |
| 8809 | 1 | < 0.1% |
| 8801 | 1 | < 0.1% |
| 8788 | 3 | |
| 8787 | 1 | < 0.1% |
| 8785 | 1 | < 0.1% |
| 8784 | 1 | < 0.1% |
| 8783 | 1 | < 0.1% |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12645.136 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1533.3962 |
|---|---|
| Coefficient of variation (CV) | 0.12126371 |
| Kurtosis | -1.300608 |
| Mean | 12645.136 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.11152313 |
| Sum | 7.2995566 × 109 |
| Variance | 2351303.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28685 | 5.0% |
| 11298 | 24996 | 4.3% |
| 11292 | 24185 | 4.2% |
| 13930 | 22073 | 3.8% |
| 12892 | 16779 | 2.9% |
| 11057 | 16674 | 2.9% |
| 12889 | 15535 | 2.7% |
| 14747 | 14679 | 2.5% |
| 12953 | 13568 | 2.4% |
| 14107 | 13355 | 2.3% |
| Other values (329) | 386733 |
| Value | Count | Frequency (%) |
| 10135 | 374 | 0.1% |
| 10136 | 116 | < 0.1% |
| 10140 | 1909 | |
| 10141 | 60 | < 0.1% |
| 10146 | 60 | < 0.1% |
| 10154 | 343 | 0.1% |
| 10155 | 90 | < 0.1% |
| 10157 | 142 | < 0.1% |
| 10158 | 210 | < 0.1% |
| 10165 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 140 | < 0.1% |
| 16218 | 145 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 1022 | |
| 15897 | 60 | < 0.1% |
| 15841 | 60 | < 0.1% |
| 15624 | 1034 | |
| 15607 | 60 | < 0.1% |
| 15582 | 52 | < 0.1% |
| 15569 | 52 | < 0.1% |
ORIGIN
Text
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1731786 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLT |
|---|---|
| 2nd row | JFK |
| 3rd row | BHM |
| 4th row | LGA |
| 5th row | BGR |
| Value | Count | Frequency (%) |
| atl | 28685 | 5.0% |
| dfw | 24996 | 4.3% |
| den | 24185 | 4.2% |
| ord | 22073 | 3.8% |
| lax | 16779 | 2.9% |
| clt | 16674 | 2.9% |
| las | 15535 | 2.7% |
| sea | 14679 | 2.5% |
| lga | 13568 | 2.4% |
| phx | 13355 | 2.3% |
| Other values (329) | 386733 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 198304 | 11.5% |
| L | 158807 | 9.2% |
| S | 148273 | 8.6% |
| D | 137166 | 7.9% |
| T | 91609 | 5.3% |
| C | 88456 | 5.1% |
| O | 88366 | 5.1% |
| M | 77730 | 4.5% |
| F | 72627 | 4.2% |
| W | 68030 | 3.9% |
| Other values (16) | 602418 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 198304 | 11.5% |
| L | 158807 | 9.2% |
| S | 148273 | 8.6% |
| D | 137166 | 7.9% |
| T | 91609 | 5.3% |
| C | 88456 | 5.1% |
| O | 88366 | 5.1% |
| M | 77730 | 4.5% |
| F | 72627 | 4.2% |
| W | 68030 | 3.9% |
| Other values (16) | 602418 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 198304 | 11.5% |
| L | 158807 | 9.2% |
| S | 148273 | 8.6% |
| D | 137166 | 7.9% |
| T | 91609 | 5.3% |
| C | 88456 | 5.1% |
| O | 88366 | 5.1% |
| M | 77730 | 4.5% |
| F | 72627 | 4.2% |
| W | 68030 | 3.9% |
| Other values (16) | 602418 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 198304 | 11.5% |
| L | 158807 | 9.2% |
| S | 148273 | 8.6% |
| D | 137166 | 7.9% |
| T | 91609 | 5.3% |
| C | 88456 | 5.1% |
| O | 88366 | 5.1% |
| M | 77730 | 4.5% |
| F | 72627 | 4.2% |
| W | 68030 | 3.9% |
| Other values (16) | 602418 |
ORIGIN_CITY_NAME
Text
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.060674 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7539431 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Charlotte, NC |
|---|---|
| 2nd row | New York, NY |
| 3rd row | Birmingham, AL |
| 4th row | New York, NY |
| 5th row | Bangor, ME |
| Value | Count | Frequency (%) |
| ca | 62634 | 4.7% |
| tx | 61128 | 4.5% |
| fl | 48495 | 3.6% |
| ny | 31097 | 2.3% |
| san | 30883 | 2.3% |
| ga | 30779 | 2.3% |
| il | 30534 | 2.3% |
| chicago | 29410 | 2.2% |
| atlanta | 28685 | 2.1% |
| new | 28578 | 2.1% |
| Other values (404) | 962163 |
Most occurring characters
| Value | Count | Frequency (%) |
| 767124 | 10.2% | |
| a | 577908 | 7.7% |
| , | 577262 | 7.7% |
| o | 415793 | 5.5% |
| e | 396008 | 5.3% |
| n | 370884 | 4.9% |
| t | 363593 | 4.8% |
| l | 335909 | 4.5% |
| i | 286281 | 3.8% |
| r | 272170 | 3.6% |
| Other values (47) | 3176499 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7539431 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 767124 | 10.2% | |
| a | 577908 | 7.7% |
| , | 577262 | 7.7% |
| o | 415793 | 5.5% |
| e | 396008 | 5.3% |
| n | 370884 | 4.9% |
| t | 363593 | 4.8% |
| l | 335909 | 4.5% |
| i | 286281 | 3.8% |
| r | 272170 | 3.6% |
| Other values (47) | 3176499 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7539431 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 767124 | 10.2% | |
| a | 577908 | 7.7% |
| , | 577262 | 7.7% |
| o | 415793 | 5.5% |
| e | 396008 | 5.3% |
| n | 370884 | 4.9% |
| t | 363593 | 4.8% |
| l | 335909 | 4.5% |
| i | 286281 | 3.8% |
| r | 272170 | 3.6% |
| Other values (47) | 3176499 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7539431 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 767124 | 10.2% | |
| a | 577908 | 7.7% |
| , | 577262 | 7.7% |
| o | 415793 | 5.5% |
| e | 396008 | 5.3% |
| n | 370884 | 4.9% |
| t | 363593 | 4.8% |
| l | 335909 | 4.5% |
| i | 286281 | 3.8% |
| r | 272170 | 3.6% |
| Other values (47) | 3176499 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1746399 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4718909 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North Carolina |
|---|---|
| 2nd row | New York |
| 3rd row | Alabama |
| 4th row | New York |
| 5th row | Maine |
| Value | Count | Frequency (%) |
| california | 62634 | 9.5% |
| texas | 61128 | 9.2% |
| florida | 48495 | 7.3% |
| new | 45477 | 6.9% |
| york | 31097 | 4.7% |
| georgia | 30779 | 4.6% |
| illinois | 30534 | 4.6% |
| carolina | 30507 | 4.6% |
| colorado | 26795 | 4.0% |
| north | 26145 | 3.9% |
| Other values (51) | 268554 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 634260 | |
| i | 529663 | 11.2% |
| o | 450969 | 9.6% |
| n | 350949 | 7.4% |
| r | 338596 | 7.2% |
| e | 289413 | 6.1% |
| s | 271594 | 5.8% |
| l | 261388 | 5.5% |
| C | 121647 | 2.6% |
| t | 114863 | 2.4% |
| Other values (37) | 1355567 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4718909 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 634260 | |
| i | 529663 | 11.2% |
| o | 450969 | 9.6% |
| n | 350949 | 7.4% |
| r | 338596 | 7.2% |
| e | 289413 | 6.1% |
| s | 271594 | 5.8% |
| l | 261388 | 5.5% |
| C | 121647 | 2.6% |
| t | 114863 | 2.4% |
| Other values (37) | 1355567 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4718909 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 634260 | |
| i | 529663 | 11.2% |
| o | 450969 | 9.6% |
| n | 350949 | 7.4% |
| r | 338596 | 7.2% |
| e | 289413 | 6.1% |
| s | 271594 | 5.8% |
| l | 261388 | 5.5% |
| C | 121647 | 2.6% |
| t | 114863 | 2.4% |
| Other values (37) | 1355567 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4718909 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 634260 | |
| i | 529663 | 11.2% |
| o | 450969 | 9.6% |
| n | 350949 | 7.4% |
| r | 338596 | 7.2% |
| e | 289413 | 6.1% |
| s | 271594 | 5.8% |
| l | 261388 | 5.5% |
| C | 121647 | 2.6% |
| t | 114863 | 2.4% |
| Other values (37) | 1355567 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.464512 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.894742 |
|---|---|
| Coefficient of variation (CV) | 0.49380306 |
| Kurtosis | -1.3066313 |
| Mean | 54.464512 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.031710474 |
| Sum | 31440293 |
| Variance | 723.32717 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 62634 | 10.9% |
| 74 | 61128 | 10.6% |
| 33 | 48495 | 8.4% |
| 22 | 31097 | 5.4% |
| 34 | 30779 | 5.3% |
| 41 | 30534 | 5.3% |
| 82 | 26795 | 4.6% |
| 36 | 24829 | 4.3% |
| 38 | 19876 | 3.4% |
| 85 | 17229 | 3.0% |
| Other values (42) | 223866 |
| Value | Count | Frequency (%) |
| 1 | 3793 | 0.7% |
| 2 | 11333 | |
| 3 | 3374 | 0.6% |
| 4 | 486 | 0.1% |
| 5 | 119 | < 0.1% |
| 11 | 1711 | 0.3% |
| 12 | 1687 | 0.3% |
| 13 | 12570 | |
| 14 | 545 | 0.1% |
| 15 | 1142 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 16886 | 2.9% |
| 92 | 6743 | 1.2% |
| 91 | 62634 | |
| 88 | 883 | 0.2% |
| 87 | 9633 | 1.7% |
| 86 | 2119 | 0.4% |
| 85 | 17229 | 3.0% |
| 84 | 2497 | 0.4% |
| 83 | 2228 | 0.4% |
| 82 | 26795 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12644.925 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1533.369 |
|---|---|
| Coefficient of variation (CV) | 0.12126359 |
| Kurtosis | -1.3004438 |
| Mean | 12644.925 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.11173399 |
| Sum | 7.2994345 × 109 |
| Variance | 2351220.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28678 | 5.0% |
| 11298 | 24985 | 4.3% |
| 11292 | 24192 | 4.2% |
| 13930 | 22082 | 3.8% |
| 12892 | 16783 | 2.9% |
| 11057 | 16658 | 2.9% |
| 12889 | 15533 | 2.7% |
| 14747 | 14669 | 2.5% |
| 12953 | 13570 | 2.4% |
| 14107 | 13346 | 2.3% |
| Other values (329) | 386766 |
| Value | Count | Frequency (%) |
| 10135 | 374 | 0.1% |
| 10136 | 116 | < 0.1% |
| 10140 | 1911 | |
| 10141 | 60 | < 0.1% |
| 10146 | 60 | < 0.1% |
| 10154 | 343 | 0.1% |
| 10155 | 90 | < 0.1% |
| 10157 | 142 | < 0.1% |
| 10158 | 211 | < 0.1% |
| 10165 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 140 | < 0.1% |
| 16218 | 146 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 1021 | |
| 15897 | 60 | < 0.1% |
| 15841 | 60 | < 0.1% |
| 15624 | 1034 | |
| 15607 | 60 | < 0.1% |
| 15582 | 52 | < 0.1% |
| 15569 | 52 | < 0.1% |
DEST
Text
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1731786 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | JFK |
|---|---|
| 2nd row | CLT |
| 3rd row | LGA |
| 4th row | BHM |
| 5th row | LGA |
| Value | Count | Frequency (%) |
| atl | 28678 | 5.0% |
| dfw | 24985 | 4.3% |
| den | 24192 | 4.2% |
| ord | 22082 | 3.8% |
| lax | 16783 | 2.9% |
| clt | 16658 | 2.9% |
| las | 15533 | 2.7% |
| sea | 14669 | 2.5% |
| lga | 13570 | 2.4% |
| phx | 13346 | 2.3% |
| Other values (329) | 386766 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 198312 | 11.5% |
| L | 158784 | 9.2% |
| S | 148266 | 8.6% |
| D | 137160 | 7.9% |
| T | 91581 | 5.3% |
| C | 88446 | 5.1% |
| O | 88364 | 5.1% |
| M | 77734 | 4.5% |
| F | 72608 | 4.2% |
| W | 68033 | 3.9% |
| Other values (16) | 602498 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 198312 | 11.5% |
| L | 158784 | 9.2% |
| S | 148266 | 8.6% |
| D | 137160 | 7.9% |
| T | 91581 | 5.3% |
| C | 88446 | 5.1% |
| O | 88364 | 5.1% |
| M | 77734 | 4.5% |
| F | 72608 | 4.2% |
| W | 68033 | 3.9% |
| Other values (16) | 602498 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 198312 | 11.5% |
| L | 158784 | 9.2% |
| S | 148266 | 8.6% |
| D | 137160 | 7.9% |
| T | 91581 | 5.3% |
| C | 88446 | 5.1% |
| O | 88364 | 5.1% |
| M | 77734 | 4.5% |
| F | 72608 | 4.2% |
| W | 68033 | 3.9% |
| Other values (16) | 602498 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 198312 | 11.5% |
| L | 158784 | 9.2% |
| S | 148266 | 8.6% |
| D | 137160 | 7.9% |
| T | 91581 | 5.3% |
| C | 88446 | 5.1% |
| O | 88364 | 5.1% |
| M | 77734 | 4.5% |
| F | 72608 | 4.2% |
| W | 68033 | 3.9% |
| Other values (16) | 602498 |
DEST_CITY_NAME
Text
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.06029 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7539209 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | Charlotte, NC |
| 3rd row | New York, NY |
| 4th row | Birmingham, AL |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 62626 | 4.7% |
| tx | 61130 | 4.5% |
| fl | 48471 | 3.6% |
| ny | 31103 | 2.3% |
| san | 30884 | 2.3% |
| ga | 30773 | 2.3% |
| il | 30547 | 2.3% |
| chicago | 29423 | 2.2% |
| atlanta | 28678 | 2.1% |
| new | 28583 | 2.1% |
| Other values (404) | 962161 |
Most occurring characters
| Value | Count | Frequency (%) |
| 767117 | 10.2% | |
| a | 577823 | 7.7% |
| , | 577262 | 7.7% |
| o | 415775 | 5.5% |
| e | 396016 | 5.3% |
| n | 370865 | 4.9% |
| t | 363521 | 4.8% |
| l | 335849 | 4.5% |
| i | 286278 | 3.8% |
| r | 272128 | 3.6% |
| Other values (47) | 3176575 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7539209 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 767117 | 10.2% | |
| a | 577823 | 7.7% |
| , | 577262 | 7.7% |
| o | 415775 | 5.5% |
| e | 396016 | 5.3% |
| n | 370865 | 4.9% |
| t | 363521 | 4.8% |
| l | 335849 | 4.5% |
| i | 286278 | 3.8% |
| r | 272128 | 3.6% |
| Other values (47) | 3176575 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7539209 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 767117 | 10.2% | |
| a | 577823 | 7.7% |
| , | 577262 | 7.7% |
| o | 415775 | 5.5% |
| e | 396016 | 5.3% |
| n | 370865 | 4.9% |
| t | 363521 | 4.8% |
| l | 335849 | 4.5% |
| i | 286278 | 3.8% |
| r | 272128 | 3.6% |
| Other values (47) | 3176575 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7539209 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 767117 | 10.2% | |
| a | 577823 | 7.7% |
| , | 577262 | 7.7% |
| o | 415775 | 5.5% |
| e | 396016 | 5.3% |
| n | 370865 | 4.9% |
| t | 363521 | 4.8% |
| l | 335849 | 4.5% |
| i | 286278 | 3.8% |
| r | 272128 | 3.6% |
| Other values (47) | 3176575 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1746607 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4718921 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | North Carolina |
| 3rd row | New York |
| 4th row | Alabama |
| 5th row | New York |
| Value | Count | Frequency (%) |
| california | 62626 | 9.5% |
| texas | 61130 | 9.2% |
| florida | 48471 | 7.3% |
| new | 45498 | 6.9% |
| york | 31103 | 4.7% |
| georgia | 30773 | 4.6% |
| illinois | 30547 | 4.6% |
| carolina | 30506 | 4.6% |
| colorado | 26808 | 4.0% |
| north | 26137 | 3.9% |
| Other values (51) | 268570 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 634211 | |
| i | 529591 | 11.2% |
| o | 450982 | 9.6% |
| n | 350904 | 7.4% |
| r | 338560 | 7.2% |
| e | 289489 | 6.1% |
| s | 271638 | 5.8% |
| l | 261390 | 5.5% |
| C | 121650 | 2.6% |
| t | 114867 | 2.4% |
| Other values (37) | 1355639 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4718921 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 634211 | |
| i | 529591 | 11.2% |
| o | 450982 | 9.6% |
| n | 350904 | 7.4% |
| r | 338560 | 7.2% |
| e | 289489 | 6.1% |
| s | 271638 | 5.8% |
| l | 261390 | 5.5% |
| C | 121650 | 2.6% |
| t | 114867 | 2.4% |
| Other values (37) | 1355639 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4718921 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 634211 | |
| i | 529591 | 11.2% |
| o | 450982 | 9.6% |
| n | 350904 | 7.4% |
| r | 338560 | 7.2% |
| e | 289489 | 6.1% |
| s | 271638 | 5.8% |
| l | 261390 | 5.5% |
| C | 121650 | 2.6% |
| t | 114867 | 2.4% |
| Other values (37) | 1355639 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4718921 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 634211 | |
| i | 529591 | 11.2% |
| o | 450982 | 9.6% |
| n | 350904 | 7.4% |
| r | 338560 | 7.2% |
| e | 289489 | 6.1% |
| s | 271638 | 5.8% |
| l | 261390 | 5.5% |
| C | 121650 | 2.6% |
| t | 114867 | 2.4% |
| Other values (37) | 1355639 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.463587 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.894312 |
|---|---|
| Coefficient of variation (CV) | 0.49380355 |
| Kurtosis | -1.3065551 |
| Mean | 54.463587 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.031741565 |
| Sum | 31439759 |
| Variance | 723.30403 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 62626 | 10.8% |
| 74 | 61130 | 10.6% |
| 33 | 48471 | 8.4% |
| 22 | 31103 | 5.4% |
| 34 | 30773 | 5.3% |
| 41 | 30547 | 5.3% |
| 82 | 26808 | 4.6% |
| 36 | 24820 | 4.3% |
| 38 | 19867 | 3.4% |
| 85 | 17230 | 3.0% |
| Other values (42) | 223887 |
| Value | Count | Frequency (%) |
| 1 | 3792 | 0.7% |
| 2 | 11330 | |
| 3 | 3381 | 0.6% |
| 4 | 486 | 0.1% |
| 5 | 119 | < 0.1% |
| 11 | 1710 | 0.3% |
| 12 | 1686 | 0.3% |
| 13 | 12576 | |
| 14 | 546 | 0.1% |
| 15 | 1139 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 16875 | 2.9% |
| 92 | 6735 | 1.2% |
| 91 | 62626 | |
| 88 | 888 | 0.2% |
| 87 | 9632 | 1.7% |
| 86 | 2121 | 0.4% |
| 85 | 17230 | 3.0% |
| 84 | 2502 | 0.4% |
| 83 | 2230 | 0.4% |
| 82 | 26808 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1242 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1339.4507 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 908 |
| median | 1327 |
| Q3 | 1750 |
| 95-th percentile | 2145 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 842 |
Descriptive statistics
| Standard deviation | 504.66987 |
|---|---|
| Coefficient of variation (CV) | 0.37677376 |
| Kurtosis | -1.0942533 |
| Mean | 1339.4507 |
| Median Absolute Deviation (MAD) | 422 |
| Skewness | 0.078501329 |
| Sum | 7.7321398 × 108 |
| Variance | 254691.68 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 11652 | 2.0% |
| 700 | 8599 | 1.5% |
| 800 | 5189 | 0.9% |
| 630 | 3964 | 0.7% |
| 900 | 3437 | 0.6% |
| 615 | 3404 | 0.6% |
| 1000 | 3281 | 0.6% |
| 830 | 3199 | 0.6% |
| 730 | 3041 | 0.5% |
| 715 | 2863 | 0.5% |
| Other values (1232) | 528633 |
| Value | Count | Frequency (%) |
| 1 | 31 | |
| 3 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 9 | 36 | |
| 10 | 21 | |
| 11 | 1 | < 0.1% |
| 12 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 911 | |
| 2358 | 91 | < 0.1% |
| 2357 | 59 | < 0.1% |
| 2356 | 101 | < 0.1% |
| 2355 | 236 | < 0.1% |
| 2354 | 47 | < 0.1% |
| 2353 | 123 | < 0.1% |
| 2352 | 28 | < 0.1% |
| 2351 | 26 | < 0.1% |
| 2350 | 214 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING
| Distinct | 1427 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 11603 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1339.6753 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 557 |
| Q1 | 906 |
| median | 1327 |
| Q3 | 1801 |
| 95-th percentile | 2204.1 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 895 |
Descriptive statistics
| Standard deviation | 527.69883 |
|---|---|
| Coefficient of variation (CV) | 0.39390054 |
| Kurtosis | -0.9713539 |
| Mean | 1339.6753 |
| Median Absolute Deviation (MAD) | 428 |
| Skewness | 0.015188589 |
| Sum | 7.577994 × 108 |
| Variance | 278466.05 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 1424 | 0.2% |
| 556 | 1343 | 0.2% |
| 557 | 1336 | 0.2% |
| 558 | 1298 | 0.2% |
| 559 | 1189 | 0.2% |
| 655 | 1121 | 0.2% |
| 554 | 1110 | 0.2% |
| 600 | 1099 | 0.2% |
| 656 | 1031 | 0.2% |
| 659 | 1006 | 0.2% |
| Other values (1417) | 553702 | |
| (Missing) | 11603 | 2.0% |
| Value | Count | Frequency (%) |
| 1 | 141 | |
| 2 | 99 | |
| 3 | 109 | |
| 4 | 90 | |
| 5 | 99 | |
| 6 | 98 | |
| 7 | 80 | |
| 8 | 86 | |
| 9 | 85 | |
| 10 | 73 |
| Value | Count | Frequency (%) |
| 2400 | 92 | |
| 2359 | 143 | |
| 2358 | 134 | |
| 2357 | 173 | |
| 2356 | 154 | |
| 2355 | 163 | |
| 2354 | 151 | |
| 2353 | 165 | |
| 2352 | 154 | |
| 2351 | 155 |
DEP_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1277 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 11607 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.912882 |
| Minimum | -48 |
|---|---|
| Maximum | 3695 |
| Zeros | 26175 |
| Zeros (%) | 4.5% |
| Negative | 281729 |
| Negative (%) | 48.8% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | -48 |
|---|---|
| 5-th percentile | -9 |
| Q1 | -5 |
| median | 0 |
| Q3 | 17 |
| 95-th percentile | 106 |
| Maximum | 3695 |
| Range | 3743 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 66.348798 |
|---|---|
| Coefficient of variation (CV) | 3.5081274 |
| Kurtosis | 179.85788 |
| Mean | 18.912882 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 9.9427138 |
| Sum | 10698166 |
| Variance | 4402.163 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 37093 | 6.4% |
| -4 | 36143 | 6.3% |
| -3 | 35781 | 6.2% |
| -2 | 33022 | 5.7% |
| -1 | 30495 | 5.3% |
| -6 | 28221 | 4.9% |
| 0 | 26175 | 4.5% |
| -7 | 23295 | 4.0% |
| -8 | 18119 | 3.1% |
| -9 | 12948 | 2.2% |
| Other values (1267) | 284363 |
| Value | Count | Frequency (%) |
| -48 | 1 | < 0.1% |
| -40 | 1 | < 0.1% |
| -35 | 1 | < 0.1% |
| -34 | 2 | < 0.1% |
| -33 | 2 | < 0.1% |
| -31 | 3 | < 0.1% |
| -30 | 7 | |
| -29 | 9 | |
| -28 | 15 | |
| -27 | 16 |
| Value | Count | Frequency (%) |
| 3695 | 1 | |
| 3011 | 1 | |
| 2940 | 1 | |
| 2869 | 1 | |
| 2856 | 1 | |
| 2675 | 1 | |
| 2479 | 1 | |
| 2366 | 1 | |
| 2276 | 1 | |
| 2165 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING
| Distinct | 176 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 12137 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.43053 |
| Minimum | 1 |
|---|---|
| Maximum | 176 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 33 |
| Maximum | 176 |
| Range | 175 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 10.105703 |
|---|---|
| Coefficient of variation (CV) | 0.57977026 |
| Kurtosis | 34.686263 |
| Mean | 17.43053 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 4.3880348 |
| Sum | 9850428 |
| Variance | 102.12523 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12 | 46676 | 8.1% |
| 13 | 46610 | 8.1% |
| 14 | 43911 | 7.6% |
| 11 | 43232 | 7.5% |
| 15 | 39598 | 6.9% |
| 10 | 35153 | 6.1% |
| 16 | 35060 | 6.1% |
| 17 | 30368 | 5.3% |
| 18 | 26135 | 4.5% |
| 9 | 24201 | 4.2% |
| Other values (166) | 194181 |
| Value | Count | Frequency (%) |
| 1 | 11 | < 0.1% |
| 2 | 18 | < 0.1% |
| 3 | 48 | < 0.1% |
| 4 | 202 | < 0.1% |
| 5 | 585 | 0.1% |
| 6 | 2449 | 0.4% |
| 7 | 6649 | 1.2% |
| 8 | 13912 | 2.4% |
| 9 | 24201 | |
| 10 | 35153 |
| Value | Count | Frequency (%) |
| 176 | 1 | < 0.1% |
| 175 | 1 | < 0.1% |
| 174 | 2 | |
| 173 | 1 | < 0.1% |
| 172 | 1 | < 0.1% |
| 171 | 2 | |
| 170 | 1 | < 0.1% |
| 169 | 4 | |
| 168 | 1 | < 0.1% |
| 167 | 3 |
TAXI_IN
Real number (ℝ)
MISSING
| Distinct | 165 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 12413 |
| Missing (%) | 2.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4008169 |
| Minimum | 1 |
|---|---|
| Maximum | 197 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 20 |
| Maximum | 197 |
| Range | 196 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 7.3927416 |
|---|---|
| Coefficient of variation (CV) | 0.88000271 |
| Kurtosis | 51.096912 |
| Mean | 8.4008169 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.1665243 |
| Sum | 4745193 |
| Variance | 54.652628 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 82134 | |
| 5 | 80872 | |
| 6 | 67273 | |
| 7 | 54781 | |
| 3 | 47728 | |
| 8 | 41116 | |
| 9 | 31910 | 5.5% |
| 10 | 25387 | 4.4% |
| 11 | 19872 | 3.4% |
| 12 | 15818 | 2.7% |
| Other values (155) | 97958 |
| Value | Count | Frequency (%) |
| 1 | 905 | 0.2% |
| 2 | 12090 | 2.1% |
| 3 | 47728 | |
| 4 | 82134 | |
| 5 | 80872 | |
| 6 | 67273 | |
| 7 | 54781 | |
| 8 | 41116 | |
| 9 | 31910 | 5.5% |
| 10 | 25387 | 4.4% |
| Value | Count | Frequency (%) |
| 197 | 1 | < 0.1% |
| 192 | 1 | < 0.1% |
| 191 | 1 | < 0.1% |
| 179 | 1 | < 0.1% |
| 175 | 1 | < 0.1% |
| 174 | 1 | < 0.1% |
| 166 | 3 | |
| 165 | 2 | |
| 164 | 1 | < 0.1% |
| 163 | 2 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1317 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1477.6757 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 658 |
| Q1 | 1047 |
| median | 1510 |
| Q3 | 1929 |
| 95-th percentile | 2302 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 882 |
Descriptive statistics
| Standard deviation | 539.7102 |
|---|---|
| Coefficient of variation (CV) | 0.36524265 |
| Kurtosis | -0.48083322 |
| Mean | 1477.6757 |
| Median Absolute Deviation (MAD) | 429 |
| Skewness | -0.31755571 |
| Sum | 8.5300605 × 108 |
| Variance | 291287.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2359 | 3284 | 0.6% |
| 2100 | 1782 | 0.3% |
| 1200 | 1700 | 0.3% |
| 1710 | 1674 | 0.3% |
| 2200 | 1670 | 0.3% |
| 1915 | 1647 | 0.3% |
| 1845 | 1646 | 0.3% |
| 1810 | 1632 | 0.3% |
| 950 | 1630 | 0.3% |
| 920 | 1566 | 0.3% |
| Other values (1307) | 559031 |
| Value | Count | Frequency (%) |
| 1 | 82 | < 0.1% |
| 2 | 126 | < 0.1% |
| 3 | 165 | < 0.1% |
| 4 | 111 | < 0.1% |
| 5 | 640 | |
| 6 | 129 | < 0.1% |
| 7 | 94 | < 0.1% |
| 8 | 108 | < 0.1% |
| 9 | 52 | < 0.1% |
| 10 | 705 |
| Value | Count | Frequency (%) |
| 2400 | 1 | < 0.1% |
| 2359 | 3284 | |
| 2358 | 718 | 0.1% |
| 2357 | 710 | 0.1% |
| 2356 | 759 | 0.1% |
| 2355 | 1111 | 0.2% |
| 2354 | 449 | 0.1% |
| 2353 | 534 | 0.1% |
| 2352 | 510 | 0.1% |
| 2351 | 489 | 0.1% |
ARR_TIME
Real number (ℝ)
MISSING
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 12413 |
| Missing (%) | 2.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1431.7519 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 414 |
| Q1 | 1019 |
| median | 1444 |
| Q3 | 1918 |
| 95-th percentile | 2256 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 899 |
Descriptive statistics
| Standard deviation | 576.26535 |
|---|---|
| Coefficient of variation (CV) | 0.40248968 |
| Kurtosis | -0.42504023 |
| Mean | 1431.7519 |
| Median Absolute Deviation (MAD) | 444 |
| Skewness | -0.39595414 |
| Sum | 8.0872361 × 108 |
| Variance | 332081.75 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1139 | 635 | 0.1% |
| 1138 | 635 | 0.1% |
| 913 | 633 | 0.1% |
| 1146 | 625 | 0.1% |
| 1636 | 619 | 0.1% |
| 1148 | 614 | 0.1% |
| 1903 | 611 | 0.1% |
| 1134 | 609 | 0.1% |
| 932 | 607 | 0.1% |
| 1128 | 607 | 0.1% |
| Other values (1430) | 558654 | |
| (Missing) | 12413 | 2.2% |
| Value | Count | Frequency (%) |
| 1 | 468 | |
| 2 | 395 | |
| 3 | 398 | |
| 4 | 371 | |
| 5 | 369 | |
| 6 | 365 | |
| 7 | 398 | |
| 8 | 403 | |
| 9 | 378 | |
| 10 | 335 |
| Value | Count | Frequency (%) |
| 2400 | 365 | |
| 2359 | 430 | |
| 2358 | 414 | |
| 2357 | 458 | |
| 2356 | 453 | |
| 2355 | 452 | |
| 2354 | 443 | |
| 2353 | 435 | |
| 2352 | 473 | |
| 2351 | 500 |
ARR_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1303 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 14458 |
| Missing (%) | 2.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.405798 |
| Minimum | -119 |
|---|---|
| Maximum | 3680 |
| Zeros | 10607 |
| Zeros (%) | 1.8% |
| Negative | 303542 |
| Negative (%) | 52.6% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | -119 |
|---|---|
| 5-th percentile | -25 |
| Q1 | -13 |
| median | -2 |
| Q3 | 17 |
| 95-th percentile | 106 |
| Maximum | 3680 |
| Range | 3799 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 68.020192 |
|---|---|
| Coefficient of variation (CV) | 4.7217232 |
| Kurtosis | 163.4349 |
| Mean | 14.405798 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 9.2428885 |
| Sum | 8107641 |
| Variance | 4626.7465 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -9 | 14573 | 2.5% |
| -11 | 14385 | 2.5% |
| -10 | 14315 | 2.5% |
| -8 | 14282 | 2.5% |
| -7 | 14183 | 2.5% |
| -12 | 14004 | 2.4% |
| -13 | 13782 | 2.4% |
| -6 | 13738 | 2.4% |
| -5 | 13209 | 2.3% |
| -14 | 13199 | 2.3% |
| Other values (1293) | 423134 | |
| (Missing) | 14458 | 2.5% |
| Value | Count | Frequency (%) |
| -119 | 1 | < 0.1% |
| -92 | 1 | < 0.1% |
| -82 | 4 | |
| -81 | 2 | < 0.1% |
| -78 | 2 | < 0.1% |
| -77 | 4 | |
| -76 | 7 | |
| -75 | 5 | |
| -74 | 8 | |
| -73 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 3680 | 1 | |
| 3045 | 1 | |
| 2941 | 1 | |
| 2913 | 1 | |
| 2856 | 1 | |
| 2679 | 1 | |
| 2485 | 1 | |
| 2376 | 1 | |
| 2290 | 1 | |
| 2160 | 1 |
CANCELLED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| 0.0 | |
|---|---|
| 1.0 | 12219 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1731786 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 565043 | |
| 1.0 | 12219 | 2.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 565043 | |
| 1.0 | 12219 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1142305 | |
| . | 577262 | |
| 1 | 12219 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1142305 | |
| . | 577262 | |
| 1 | 12219 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1142305 | |
| . | 577262 | |
| 1 | 12219 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1142305 | |
| . | 577262 | |
| 1 | 12219 | 0.7% |
CANCELLATION_CODE
Categorical
MISSING
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 565043 |
| Missing (%) | 97.9% |
| Memory size | 4.4 MiB |
| B | |
|---|---|
| A | |
| C | |
| D | 13 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12219 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| B | 5223 | 0.9% |
| A | 4669 | 0.8% |
| C | 2314 | 0.4% |
| D | 13 | < 0.1% |
| (Missing) | 565043 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 5223 | |
| a | 4669 | |
| c | 2314 | |
| d | 13 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 5223 | |
| A | 4669 | |
| C | 2314 | |
| D | 13 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12219 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 5223 | |
| A | 4669 | |
| C | 2314 | |
| D | 13 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12219 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 5223 | |
| A | 4669 | |
| C | 2314 | |
| D | 13 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12219 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 5223 | |
| A | 4669 | |
| C | 2314 | |
| D | 13 | 0.1% |
DIVERTED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| 0.0 | |
|---|---|
| 1.0 | 2239 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1731786 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 575023 | |
| 1.0 | 2239 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 575023 | |
| 1.0 | 2239 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1152285 | |
| . | 577262 | |
| 1 | 2239 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1152285 | |
| . | 577262 | |
| 1 | 2239 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1152285 | |
| . | 577262 | |
| 1 | 2239 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1731786 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1152285 | |
| . | 577262 | |
| 1 | 2239 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 14458 |
| Missing (%) | 2.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 114.82299 |
| Minimum | 8 |
|---|---|
| Maximum | 645 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 63 |
| median | 97 |
| Q3 | 144 |
| 95-th percentile | 275 |
| Maximum | 645 |
| Range | 637 |
| Interquartile range (IQR) | 81 |
Descriptive statistics
| Standard deviation | 70.987022 |
|---|---|
| Coefficient of variation (CV) | 0.61823006 |
| Kurtosis | 2.0979689 |
| Mean | 114.82299 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 1.3653817 |
| Sum | 64622836 |
| Variance | 5039.1573 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 62 | 4835 | 0.8% |
| 64 | 4791 | 0.8% |
| 63 | 4765 | 0.8% |
| 66 | 4707 | 0.8% |
| 61 | 4693 | 0.8% |
| 65 | 4679 | 0.8% |
| 60 | 4586 | 0.8% |
| 54 | 4586 | 0.8% |
| 53 | 4538 | 0.8% |
| 43 | 4538 | 0.8% |
| Other values (589) | 516086 | |
| (Missing) | 14458 | 2.5% |
| Value | Count | Frequency (%) |
| 8 | 7 | < 0.1% |
| 9 | 15 | < 0.1% |
| 10 | 21 | < 0.1% |
| 11 | 11 | < 0.1% |
| 12 | 13 | < 0.1% |
| 13 | 21 | < 0.1% |
| 14 | 32 | < 0.1% |
| 15 | 38 | < 0.1% |
| 16 | 97 | |
| 17 | 223 |
| Value | Count | Frequency (%) |
| 645 | 1 | < 0.1% |
| 627 | 1 | < 0.1% |
| 625 | 1 | < 0.1% |
| 624 | 1 | < 0.1% |
| 622 | 1 | < 0.1% |
| 620 | 3 | |
| 619 | 2 | |
| 618 | 1 | < 0.1% |
| 617 | 1 | < 0.1% |
| 616 | 1 | < 0.1% |
CARRIER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1015 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 424994 |
| Missing (%) | 73.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.337241 |
| Minimum | 0 |
|---|---|
| Maximum | 3045 |
| Zeros | 64488 |
| Zeros (%) | 11.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 23 |
| 95-th percentile | 109 |
| Maximum | 3045 |
| Range | 3045 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 80.019964 |
|---|---|
| Coefficient of variation (CV) | 3.038282 |
| Kurtosis | 161.56186 |
| Mean | 26.337241 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 9.9898461 |
| Sum | 4010319 |
| Variance | 6403.1947 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 64488 | 11.2% |
| 1 | 2952 | 0.5% |
| 2 | 2930 | 0.5% |
| 4 | 2814 | 0.5% |
| 3 | 2799 | 0.5% |
| 6 | 2786 | 0.5% |
| 7 | 2602 | 0.5% |
| 5 | 2592 | 0.4% |
| 15 | 2504 | 0.4% |
| 8 | 2484 | 0.4% |
| Other values (1005) | 63317 | 11.0% |
| (Missing) | 424994 |
| Value | Count | Frequency (%) |
| 0 | 64488 | |
| 1 | 2952 | 0.5% |
| 2 | 2930 | 0.5% |
| 3 | 2799 | 0.5% |
| 4 | 2814 | 0.5% |
| 5 | 2592 | 0.4% |
| 6 | 2786 | 0.5% |
| 7 | 2602 | 0.5% |
| 8 | 2484 | 0.4% |
| 9 | 2358 | 0.4% |
| Value | Count | Frequency (%) |
| 3045 | 1 | |
| 2940 | 1 | |
| 2869 | 1 | |
| 2856 | 1 | |
| 2675 | 1 | |
| 2479 | 1 | |
| 2276 | 1 | |
| 2160 | 1 | |
| 1996 | 1 | |
| 1970 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 479 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 424994 |
| Missing (%) | 73.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1409817 |
| Minimum | 0 |
|---|---|
| Maximum | 1489 |
| Zeros | 141926 |
| Zeros (%) | 24.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 15 |
| Maximum | 1489 |
| Range | 1489 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 30.571241 |
|---|---|
| Coefficient of variation (CV) | 7.382607 |
| Kurtosis | 553.68909 |
| Mean | 4.1409817 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.479841 |
| Sum | 630539 |
| Variance | 934.60075 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 141926 | 24.6% |
| 10 | 227 | < 0.1% |
| 6 | 220 | < 0.1% |
| 2 | 203 | < 0.1% |
| 9 | 192 | < 0.1% |
| 1 | 190 | < 0.1% |
| 7 | 188 | < 0.1% |
| 8 | 186 | < 0.1% |
| 20 | 185 | < 0.1% |
| 4 | 185 | < 0.1% |
| Other values (469) | 8566 | 1.5% |
| (Missing) | 424994 |
| Value | Count | Frequency (%) |
| 0 | 141926 | |
| 1 | 190 | < 0.1% |
| 2 | 203 | < 0.1% |
| 3 | 175 | < 0.1% |
| 4 | 185 | < 0.1% |
| 5 | 184 | < 0.1% |
| 6 | 220 | < 0.1% |
| 7 | 188 | < 0.1% |
| 8 | 186 | < 0.1% |
| 9 | 192 | < 0.1% |
| Value | Count | Frequency (%) |
| 1489 | 1 | |
| 1429 | 1 | |
| 1239 | 1 | |
| 1197 | 1 | |
| 1159 | 1 | |
| 1150 | 1 | |
| 1130 | 1 | |
| 1105 | 1 | |
| 1086 | 1 | |
| 1085 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 450 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 424994 |
| Missing (%) | 73.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.432008 |
| Minimum | 0 |
|---|---|
| Maximum | 1708 |
| Zeros | 79641 |
| Zeros (%) | 13.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 16 |
| 95-th percentile | 60 |
| Maximum | 1708 |
| Range | 1708 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 34.309573 |
|---|---|
| Coefficient of variation (CV) | 2.5543145 |
| Kurtosis | 280.10376 |
| Mean | 13.432008 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.36759 |
| Sum | 2045265 |
| Variance | 1177.1468 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 79641 | 13.8% |
| 1 | 4169 | 0.7% |
| 2 | 2951 | 0.5% |
| 3 | 2740 | 0.5% |
| 4 | 2555 | 0.4% |
| 5 | 2444 | 0.4% |
| 15 | 2412 | 0.4% |
| 16 | 2285 | 0.4% |
| 6 | 2236 | 0.4% |
| 7 | 2165 | 0.4% |
| Other values (440) | 48670 | 8.4% |
| (Missing) | 424994 |
| Value | Count | Frequency (%) |
| 0 | 79641 | |
| 1 | 4169 | 0.7% |
| 2 | 2951 | 0.5% |
| 3 | 2740 | 0.5% |
| 4 | 2555 | 0.4% |
| 5 | 2444 | 0.4% |
| 6 | 2236 | 0.4% |
| 7 | 2165 | 0.4% |
| 8 | 1968 | 0.3% |
| 9 | 2025 | 0.4% |
| Value | Count | Frequency (%) |
| 1708 | 1 | |
| 1372 | 1 | |
| 1344 | 1 | |
| 1306 | 1 | |
| 1252 | 1 | |
| 1214 | 1 | |
| 1190 | 1 | |
| 1144 | 1 | |
| 1129 | 1 | |
| 1120 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 107 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 424994 |
| Missing (%) | 73.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14624215 |
| Minimum | 0 |
|---|---|
| Maximum | 309 |
| Zeros | 151369 |
| Zeros (%) | 26.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 309 |
| Range | 309 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.9493141 |
|---|---|
| Coefficient of variation (CV) | 20.167333 |
| Kurtosis | 2440.9965 |
| Mean | 0.14624215 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 40.745696 |
| Sum | 22268 |
| Variance | 8.6984539 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 151369 | 26.2% |
| 16 | 37 | < 0.1% |
| 14 | 36 | < 0.1% |
| 12 | 33 | < 0.1% |
| 21 | 33 | < 0.1% |
| 8 | 33 | < 0.1% |
| 10 | 32 | < 0.1% |
| 7 | 31 | < 0.1% |
| 6 | 30 | < 0.1% |
| 17 | 30 | < 0.1% |
| Other values (97) | 604 | 0.1% |
| (Missing) | 424994 |
| Value | Count | Frequency (%) |
| 0 | 151369 | |
| 1 | 22 | < 0.1% |
| 2 | 15 | < 0.1% |
| 3 | 21 | < 0.1% |
| 4 | 17 | < 0.1% |
| 5 | 27 | < 0.1% |
| 6 | 30 | < 0.1% |
| 7 | 31 | < 0.1% |
| 8 | 33 | < 0.1% |
| 9 | 26 | < 0.1% |
| Value | Count | Frequency (%) |
| 309 | 1 | |
| 259 | 1 | |
| 205 | 1 | |
| 192 | 1 | |
| 168 | 2 | |
| 164 | 1 | |
| 158 | 1 | |
| 155 | 1 | |
| 151 | 1 | |
| 149 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 799 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 424994 |
| Missing (%) | 73.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.211791 |
| Minimum | 0 |
|---|---|
| Maximum | 3581 |
| Zeros | 68409 |
| Zeros (%) | 11.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 7 |
| Q3 | 37 |
| 95-th percentile | 135 |
| Maximum | 3581 |
| Range | 3581 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 67.132402 |
|---|---|
| Coefficient of variation (CV) | 2.1508667 |
| Kurtosis | 142.55055 |
| Mean | 31.211791 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 7.9230392 |
| Sum | 4752557 |
| Variance | 4506.7593 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 68409 | 11.9% |
| 15 | 1983 | 0.3% |
| 16 | 1810 | 0.3% |
| 17 | 1719 | 0.3% |
| 18 | 1691 | 0.3% |
| 19 | 1604 | 0.3% |
| 20 | 1540 | 0.3% |
| 21 | 1500 | 0.3% |
| 14 | 1459 | 0.3% |
| 22 | 1393 | 0.2% |
| Other values (789) | 69160 | 12.0% |
| (Missing) | 424994 |
| Value | Count | Frequency (%) |
| 0 | 68409 | |
| 1 | 1054 | 0.2% |
| 2 | 1074 | 0.2% |
| 3 | 1068 | 0.2% |
| 4 | 1128 | 0.2% |
| 5 | 1155 | 0.2% |
| 6 | 1292 | 0.2% |
| 7 | 1288 | 0.2% |
| 8 | 1243 | 0.2% |
| 9 | 1228 | 0.2% |
| Value | Count | Frequency (%) |
| 3581 | 1 | |
| 2366 | 1 | |
| 1787 | 1 | |
| 1734 | 1 | |
| 1547 | 1 | |
| 1514 | 1 | |
| 1513 | 1 | |
| 1451 | 1 | |
| 1450 | 1 | |
| 1437 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 6/5/2023 12:00:00 AM | 9E | 4901 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12478 | JFK | New York, NY | New York | 22 | 1942 | 1944.0 | 2.0 | 27.0 | 14.0 | 2200 | 2151.0 | -9.0 | 0.0 | NaN | 0.0 | 86.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 6/5/2023 12:00:00 AM | 9E | 4901 | 12478 | JFK | New York, NY | New York | 22 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 1626 | 1620.0 | -6.0 | 24.0 | 11.0 | 1850 | 1818.0 | -32.0 | 0.0 | NaN | 0.0 | 83.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 6/5/2023 12:00:00 AM | 9E | 4903 | 10599 | BHM | Birmingham, AL | Alabama | 51 | 12953 | LGA | New York, NY | New York | 22 | 1125 | 1123.0 | -2.0 | 15.0 | 6.0 | 1458 | 1444.0 | -14.0 | 0.0 | NaN | 0.0 | 120.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 6/5/2023 12:00:00 AM | 9E | 4903 | 12953 | LGA | New York, NY | New York | 22 | 10599 | BHM | Birmingham, AL | Alabama | 51 | 850 | 846.0 | -4.0 | 37.0 | 3.0 | 1039 | 1024.0 | -15.0 | 0.0 | NaN | 0.0 | 118.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 6/5/2023 12:00:00 AM | 9E | 4904 | 10581 | BGR | Bangor, ME | Maine | 12 | 12953 | LGA | New York, NY | New York | 22 | 1218 | 1215.0 | -3.0 | 10.0 | 6.0 | 1359 | 1337.0 | -22.0 | 0.0 | NaN | 0.0 | 66.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 6/5/2023 12:00:00 AM | 9E | 4904 | 12953 | LGA | New York, NY | New York | 22 | 10581 | BGR | Bangor, ME | Maine | 12 | 945 | 941.0 | -4.0 | 45.0 | 4.0 | 1133 | 1133.0 | 0.0 | 0.0 | NaN | 0.0 | 63.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 6/5/2023 12:00:00 AM | 9E | 4905 | 12953 | LGA | New York, NY | New York | 22 | 11267 | DAY | Dayton, OH | Ohio | 44 | 2029 | 2025.0 | -4.0 | 39.0 | 6.0 | 2237 | 2232.0 | -5.0 | 0.0 | NaN | 0.0 | 82.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 6/5/2023 12:00:00 AM | 9E | 4906 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 13377 | MLU | Monroe, LA | Louisiana | 72 | 1010 | 1022.0 | 12.0 | 44.0 | 2.0 | 1048 | 1121.0 | 33.0 | 0.0 | NaN | 0.0 | 73.0 | 12.0 | 0.0 | 21.0 | 0.0 | 0.0 |
| 8 | 1 | 6/5/2023 12:00:00 AM | 9E | 4906 | 13377 | MLU | Monroe, LA | Louisiana | 72 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 1133 | 1200.0 | 27.0 | 9.0 | 10.0 | 1419 | 1430.0 | 11.0 | 0.0 | NaN | 0.0 | 71.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 6/5/2023 12:00:00 AM | 9E | 4907 | 10581 | BGR | Bangor, ME | Maine | 12 | 12478 | JFK | New York, NY | New York | 22 | 1915 | 1906.0 | -9.0 | 17.0 | 38.0 | 2056 | 2104.0 | 8.0 | 0.0 | NaN | 0.0 | 63.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 577252 | 7 | 6/25/2023 12:00:00 AM | YX | 5826 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 12953 | LGA | New York, NY | New York | 22 | 1900 | 2003.0 | 63.0 | 87.0 | 11.0 | 2043 | 2222.0 | 99.0 | 0.0 | NaN | 0.0 | 41.0 | 0.0 | 63.0 | 36.0 | 0.0 | 0.0 |
| 577253 | 7 | 6/25/2023 12:00:00 AM | YX | 5827 | 11278 | DCA | Washington, DC | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 900 | 852.0 | -8.0 | 17.0 | 9.0 | 1052 | 1027.0 | -25.0 | 0.0 | NaN | 0.0 | 69.0 | NaN | NaN | NaN | NaN | NaN |
| 577254 | 7 | 6/25/2023 12:00:00 AM | YX | 5829 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 610 | 627.0 | 17.0 | 10.0 | 9.0 | 805 | 810.0 | 5.0 | 0.0 | NaN | 0.0 | 84.0 | NaN | NaN | NaN | NaN | NaN |
| 577255 | 7 | 6/25/2023 12:00:00 AM | YX | 5833 | 12478 | JFK | New York, NY | New York | 22 | 11066 | CMH | Columbus, OH | Ohio | 44 | 2130 | 2201.0 | 31.0 | 14.0 | 17.0 | 2344 | 2343.0 | -1.0 | 0.0 | NaN | 0.0 | 71.0 | NaN | NaN | NaN | NaN | NaN |
| 577256 | 7 | 6/25/2023 12:00:00 AM | YX | 5834 | 12953 | LGA | New York, NY | New York | 22 | 13485 | MSN | Madison, WI | Wisconsin | 45 | 2035 | 2250.0 | 135.0 | 31.0 | 6.0 | 2224 | 17.0 | 113.0 | 0.0 | NaN | 0.0 | 110.0 | 49.0 | 0.0 | 0.0 | 0.0 | 64.0 |
| 577257 | 7 | 6/25/2023 12:00:00 AM | YX | 5839 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11066 | CMH | Columbus, OH | Ohio | 44 | 1335 | 1331.0 | -4.0 | 16.0 | 9.0 | 1550 | 1529.0 | -21.0 | 0.0 | NaN | 0.0 | 93.0 | NaN | NaN | NaN | NaN | NaN |
| 577258 | 7 | 6/25/2023 12:00:00 AM | YX | 5839 | 11066 | CMH | Columbus, OH | Ohio | 44 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1700 | 1714.0 | 14.0 | 48.0 | 10.0 | 1911 | 1946.0 | 35.0 | 0.0 | NaN | 0.0 | 94.0 | 0.0 | 0.0 | 35.0 | 0.0 | 0.0 |
| 577259 | 7 | 6/25/2023 12:00:00 AM | YX | 5844 | 12953 | LGA | New York, NY | New York | 22 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1100 | 1056.0 | -4.0 | 23.0 | 8.0 | 1230 | 1209.0 | -21.0 | 0.0 | NaN | 0.0 | 42.0 | NaN | NaN | NaN | NaN | NaN |
| 577260 | 7 | 6/25/2023 12:00:00 AM | YX | 5845 | 10154 | ACK | Nantucket, MA | Massachusetts | 13 | 12478 | JFK | New York, NY | New York | 22 | 1140 | 1647.0 | 307.0 | 22.0 | 18.0 | 1304 | 1805.0 | 301.0 | 0.0 | NaN | 0.0 | 38.0 | 0.0 | 301.0 | 0.0 | 0.0 | 0.0 |
| 577261 | 7 | 6/25/2023 12:00:00 AM | YX | 5846 | 11066 | CMH | Columbus, OH | Ohio | 44 | 12478 | JFK | New York, NY | New York | 22 | 1152 | 1157.0 | 5.0 | 14.0 | 11.0 | 1359 | 1351.0 | -8.0 | 0.0 | NaN | 0.0 | 89.0 | NaN | NaN | NaN | NaN | NaN |